Modeler(PBA插件)安装

将 "Modeler.zip" 解压缩到 "pentaho-solutions\system" 目录。

在PBA（PostgreSQL）的存储库数据库中创建一个名为 "datafor" 的数据库。

CREATE DATABASE datafor WITH OWNER = postgres ENCODING = 'UTF8' TABLESPACE = pg_default;
GRANT ALL PRIVILEGES ON DATABASE datafor to postgres;

在 "datafor" 数据库中创建 6 个表。

表: auth_config

CREATE TABLE "public"."auth_config" (
      "id" varchar(250) COLLATE "pg_catalog"."default" NOT NULL,
      "dbconn" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
      "schema" varchar(255) COLLATE "pg_catalog"."default",
      "tbname" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
      "cols" text COLLATE "pg_catalog"."default",
      "rows" text COLLATE "pg_catalog"."default",
      "sql" text COLLATE "pg_catalog"."default",
      "enable" char(1) COLLATE "pg_catalog"."default" NOT NULL,
      "visible" char(1) COLLATE "pg_catalog"."default" NOT NULL,
      "add_time" timestamp(6),
      "add_by" varchar(200) COLLATE "pg_catalog"."default",
      "update_time" timestamp(6),
      "update_by" varchar(200) COLLATE "pg_catalog"."default",
      "name" varchar(255) COLLATE "pg_catalog"."default",
      "type" varchar(1) COLLATE "pg_catalog"."default",
      "editable" char(1) COLLATE "pg_catalog"."default" NOT NULL DEFAULT 1
);
ALTER TABLE "public"."auth_config" ADD CONSTRAINT "auth_config_pkey" PRIMARY KEY ("id");

表: gis_config

CREATE TABLE "public"."gis_config" (
 "engine" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
 "name" varchar(255) COLLATE "pg_catalog"."zh-Hans-CN-x-icu" NOT NULL,
 "longitude" varchar(255) COLLATE "pg_catalog"."default",
 "latitude" varchar(255) COLLATE "pg_catalog"."default"
 
);
ALTER TABLE "public"."gis_config" ADD CONSTRAINT "gis_config_pkey" PRIMARY KEY ("engine", "name");

表: dict_config

CREATE TABLE "public"."dict_config" (
      "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
      "name" varchar(255) COLLATE "pg_catalog"."default",
      "dbconn" varchar(255) COLLATE "pg_catalog"."default",
      "schema" varchar(255) COLLATE "pg_catalog"."default",
      "detail" text COLLATE "pg_catalog"."default",
      "type" char(1) COLLATE "pg_catalog"."default",
      "default" varchar(255) COLLATE "pg_catalog"."default",
      "desc" varchar(255) COLLATE "pg_catalog"."default",
      "add_time" timestamp(6),
      "update_time" timestamp(6),
      "add_by" varchar(255) COLLATE "pg_catalog"."default",
      "update_by" varchar(255) COLLATE "pg_catalog"."default",
      "expire" varchar(255) COLLATE "pg_catalog"."default"
);
ALTER TABLE "public"."dict_config" ADD CONSTRAINT "dict_config_pkey" PRIMARY KEY ("id");

表: dict_map

CREATE TABLE "public"."dict_map" (
 "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
 "dict" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
 "type" varchar(1) COLLATE "pg_catalog"."default" NOT NULL,
 "dbconn" varchar(255) COLLATE "pg_catalog"."default",
 "schema" varchar(255) COLLATE "pg_catalog"."default",
 "table" varchar(255) COLLATE "pg_catalog"."default",
 "field" varchar(255) COLLATE "pg_catalog"."default"
);
ALTER TABLE "public"."dict_map" ADD CONSTRAINT "dict_map_pkey" PRIMARY KEY ("id");

表: query_config

CREATE TABLE "public"."query_config" (
       "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
       "dbconn" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
       "schema" varchar(255) COLLATE "pg_catalog"."default",
       "tbname" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
       "sql" text COLLATE "pg_catalog"."default",
       "enable" char(1) COLLATE "pg_catalog"."default" NOT NULL,
       "add_time" timestamp(6),
       "add_by" varchar(200) COLLATE "pg_catalog"."default",
       "update_time" timestamp(6),
       "update_by" varchar(200) COLLATE "pg_catalog"."default"
);
ALTER TABLE "public"."query_config" ADD CONSTRAINT "query_config_pkey" PRIMARY KEY ("id");

表: parameter_config

CREATE TABLE "public"."parameter_config" (
           "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
           "name" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
           "effectconn" varchar(200) COLLATE "pg_catalog"."default",
           "dbconn" varchar(200) COLLATE "pg_catalog"."default",
           "schema" varchar(200) COLLATE "pg_catalog"."default",
           "detail" text COLLATE "pg_catalog"."default",
           "type" char(1) COLLATE "pg_catalog"."default",
           "default" varchar(2000) COLLATE "pg_catalog"."default",
           "datatype" varchar(2) COLLATE "pg_catalog"."default",
           "desc" varchar(2000) COLLATE "pg_catalog"."default",
           "add_time" timestamp(6),
           "update_time" timestamp(6),
           "add_by" varchar(200) COLLATE "pg_catalog"."default",
           "update_by" varchar(200) COLLATE "pg_catalog"."default"
);
ALTER TABLE "public"."parameter_config" ADD CONSTRAINT "parameter_config_pkey" PRIMARY KEY ("id");

Create a database connection named "datafor_modeler_auth". Set the value of the "stringtype" option to "unspecified," and enable connection pooling.
重启PBA